Why is the `remove rows` button not always present in MySQL Workbench?
Posted
by
Shawn
on Super User
See other posts from Super User
or by Shawn
Published on 2012-09-12T16:03:06Z
Indexed on
2012/09/25
15:40 UTC
Read the original article
Hit count: 244
mysql-workbench
I'm using MySQL Workbench to remove rows from a table in my database. Most of the time, I will simply write a select statement, then select the rows I want to erase and use the remove rows
button (circled in the screenshot below).
But sometimes (quite often actually), the remove rows
button does not appear. Instead, I get something like the screenshot below:
The remove rows
button is not there and the remove rows
option is grayed out in the context menu, so basically, I can't remove rows... The only way I've found of solving this issue is to run the select query many times until the button appears (it usually does after 3 of 4 times).
Does anyone know why this is happening?
UPDATE
Today, I've been running a select query dozens of times and the button never appears. It seems my incomprehensible workaround no longer works... Help!
btw: Using a delete statement does work, though I would rather not have to write one for each row I want to remove as this happens quite frequently during development...
© Super User or respective owner